Problem Note 70059: Removing configuration of SAS® Factory Miner 15.2 removes the SharedServices entry from the SASServer11_1/conf/server.xml file
 |  |  |  |
As a result of removing the SharedServices connection entry from the SASServer11_1/conf/server.xml file, the web applications (if deployed on SASServer11) for the following will not be able to start:
- SAS® Model Manager
- SAS® Enterprise Miner™
- SAS® Forecast Server
The SharedServices connection is incorrectly removed from the server.xml file because, during the Removing Existing Configuration step, SAS Factory Miner sets the /Lev#/Web/Scripts/AppServer/props/appserver.properties for SASServer11 and the following strings are left:
datasource.##.isDeleted=false
datasource.##.jndiName=sas/jdbc/DMServices
It also changes ShareServices, isDeleted=true:
datasource.17.isDeleted=true
datasource.17.jndiName=sas/jdbc/SharedServices
In the Lev#/Web/Logs/SASServer11*/server.log, these errors are generated at the start:
| ERROR | [ContextLoader] | Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.sas.svcs.springframework.config.DefaultProvidedPropertyPlaceholderConfigurer#0': Cannot resolve reference to bean 'environmentProperties' while setting bean property 'properties'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'environmentProperties': Cannot resolve reference to bean 'datasource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'datasource': Invocation of init method failed; nested exception is javax.naming.NameNotFoundException: Name [jdbc/SASAPP] is not bound in this Context. Unable to find [jdbc].
As a result of the app.servers file having isDeleted=false for the DMServices database, this connection information is not removed from the server.xml file:
<Resource auth="Container" driverClassName="org.postgresql.Driver" factory="com.sas.vfabrictcsvr.atomikos.BeanFactory" localTransactionMode="true" maxPoolSize="250" minPoolSize="10" name="sas/jdbc/DMServices" password="${pw.sas.jdbc.DMServices}" testQuery="select 1" type="com.atomikos.jdbc.nonxa.AtomikosNonXADataSourceBean" uniqueResourceName="sas/jdbc/DMServices" url="jdbc:postgresql://sas-aap.demo.sas.com:10432/DMServices" user="DMServices"/>
A hot fix is planned for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Factory Miner | Microsoft® Windows® for x64 | ||
| Microsoft Windows 8 Enterprise 32-bit | ||||
| Microsoft Windows 8 Enterprise x64 | ||||
| Microsoft Windows 8 Pro 32-bit | ||||
| Microsoft Windows 8 Pro x64 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | ||||
| Microsoft Windows 8.1 Enterprise x64 | ||||
| Microsoft Windows 8.1 Pro 32-bit | ||||
| Microsoft Windows 8.1 Pro x64 | ||||
| Microsoft Windows 10 | ||||
| Microsoft Windows 11 | ||||
| Microsoft Windows 95/98 | ||||
| Microsoft Windows 2000 Advanced Server | ||||
| Microsoft Windows 2000 Datacenter Server | ||||
| Microsoft Windows 2000 Server | ||||
| Microsoft Windows 2000 Professional | ||||
| Microsoft Windows NT Workstation | ||||
| Microsoft Windows Server 2003 Datacenter Edition | ||||
| Microsoft Windows Server 2003 Enterprise Edition | ||||
| Microsoft Windows Server 2003 Standard Edition | ||||
| Microsoft Windows Server 2003 for x64 | ||||
| Microsoft Windows Server 2008 | ||||
| Microsoft Windows Server 2008 R2 | ||||
| Microsoft Windows Server 2008 for x64 | ||||
| Microsoft Windows Server 2012 Datacenter | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M8 | |||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M8 | |||
| Microsoft Windows Server 2012 Std | ||||
| Microsoft Windows Server 2016 | 9.4 TS1M8 | |||
| Microsoft Windows Server 2019 | 9.4 TS1M8 | |||
| Microsoft Windows Server 2022 | ||||
| Microsoft Windows XP Professional | ||||
| Windows 7 Enterprise 32 bit | ||||
| Windows 7 Enterprise x64 | ||||
| Windows 7 Home Premium 32 bit | ||||
| Windows 7 Home Premium x64 | ||||
| Windows 7 Professional 32 bit | ||||
| Windows 7 Professional x64 | ||||
| Windows 7 Ultimate 32 bit | ||||
| Windows 7 Ultimate x64 | ||||
| Windows Millennium Edition (Me) | ||||
| Windows Vista | ||||
| Windows Vista for x64 | ||||
| 64-bit Enabled AIX | 9.4 TS1M8 | |||
| 64-bit Enabled Solaris | ||||
| HP-UX IPF | 9.4 TS1M8 | |||
| Linux for x64 | 9.4 TS1M8 | |||
| Solaris for x64 | ||||
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2023-05-02 14:22:07 |
| Date Created: | 2023-05-01 10:01:49 |